/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-05-05 19:40:50
*/


-- ----------------------------
-- Table structure for tb0050
-- ----------------------------
DROP TABLE [dbo].[tb0050]
GO
CREATE TABLE [dbo].[tb0050] (
[S] varchar(20) NOT NULL ,
[STypeID] varchar(3) NOT NULL ,
[SName] nvarchar(150) NULL ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL ,
[Disabled] tinyint NOT NULL DEFAULT((0))
)


GO

-- ----------------------------
-- Records of tb0050
-- ----------------------------
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'KH', N'O01', N'Khách hàng', N'2007-12-11 14:57:38.607', N'ADMIN', N'2007-12-11 14:57:38.607', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'CC', N'O01', N'Nhà cung cấp', N'2007-12-11 14:57:50.607', N'ADMIN', N'2007-12-11 14:57:50.607', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NN', N'O01', N'Cô quan nhaø nöôùc', N'2007-12-11 14:58:10.623', N'ADMIN', N'2007-12-11 14:58:10.623', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NH', N'O01', N'Ngaân haøng', N'2007-12-11 14:58:20.763', N'ADMIN', N'2007-12-11 14:58:20.763', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'OT', N'O01', N'Khaùc', N'2007-12-11 14:58:45.717', N'ADMIN', N'2013-06-21 08:51:00.857', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'KH', N'O02', N'KHAÙNH HOØA', N'2013-01-25 14:02:48.330', N'ADMIN', N'2013-01-25 14:02:48.330', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'LD', N'O02', N'LAÂM ÑOÀNG', N'2013-01-25 14:05:12.177', N'ADMIN', N'2013-01-25 14:05:12.177', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NT', N'O02', N'NINH THUAÄN', N'2013-01-25 14:05:29.587', N'ADMIN', N'2013-01-25 14:05:29.587', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'BL', N'O02', N'BAC LIEU', N'2013-01-25 16:00:18.657', N'ADMIN', N'2013-01-25 16:00:18.657', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NV', N'O01', N'Nhaân vieân', N'2008-05-29 10:47:56.827', N'ADMIN', N'2008-05-29 10:47:56.827', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'BR', N'O02', N'BAØ RÒA', N'2013-01-25 16:02:03.980', N'ADMIN', N'2013-01-25 16:02:03.980', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'CM', N'O02', N'CAØ MAU', N'2013-01-25 16:02:23.727', N'ADMIN', N'2013-01-25 16:02:23.727', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'CT', N'O02', N'CAÀN THÔ', N'2013-01-25 16:02:34.880', N'ADMIN', N'2013-01-25 16:02:34.880', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'HN', N'O02', N'HAØ NOÄI', N'2013-01-25 16:02:56.647', N'ADMIN', N'2013-01-25 16:02:56.647', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'KG', N'O02', N'KIEÂN GIANG', N'2013-01-25 16:03:05.803', N'ADMIN', N'2013-01-25 16:03:05.803', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'SG', N'O02', N'SAØI GOØN', N'2013-01-25 16:03:31.587', N'ADMIN', N'2013-01-25 16:03:31.587', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'TH', N'O02', N'THANH HOÙA', N'2013-01-25 16:03:42.380', N'ADMIN', N'2013-01-25 16:03:42.380', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'VL', N'O02', N'VÓNH LONG', N'2013-01-25 16:04:05.590', N'ADMIN', N'2013-01-25 16:04:05.590', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'CL', N'O03', N'CAM LAÂM', N'2013-01-25 16:05:36.993', N'ADMIN', N'2013-01-25 16:05:36.993', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'DK', N'O03', N'DIEÂN KHAÙNH', N'2013-01-25 16:05:54.310', N'ADMIN', N'2013-01-25 16:05:54.310', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NT', N'O03', N'NHA TRANG', N'2013-01-25 16:06:27.163', N'ADMIN', N'2013-01-25 16:06:27.163', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'VN', N'O03', N'VAÏN NINH', N'2013-01-25 16:06:52.517', N'ADMIN', N'2013-01-25 16:06:52.517', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'DN', N'O02', N'ÑAØ NAÜNG', N'2013-01-25 16:31:47.667', N'ADMIN', N'2013-01-25 16:31:47.667', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'TG', N'O02', N'TIEÀN GIANG ', N'2013-01-25 18:45:12.713', N'ADMIN', N'2013-01-25 18:45:12.713', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'BT', N'O02', N'BÌNH THUAÄN', N'2013-01-26 10:14:34.767', N'ADMIN', N'2013-01-26 10:14:34.767', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NI', N'O03', N'NINH HAÛI', N'2013-01-26 10:15:06.310', N'ADMIN', N'2013-01-26 10:15:06.310', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NP', N'O03', N'NINH PHÖÔÙC', N'2013-01-26 10:17:02.997', N'ADMIN', N'2013-01-26 10:17:02.997', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NS', N'O03', N'NINH SÔN', N'2013-01-26 10:17:09.690', N'ADMIN', N'2013-01-26 10:17:09.690', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'PR', N'O03', N'PHAN RANG', N'2013-01-26 10:17:19.173', N'ADMIN', N'2013-01-26 10:17:19.173', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'TN', N'O03', N'THUAÄN NAM', N'2013-01-26 10:17:28.613', N'ADMIN', N'2013-01-26 10:17:28.613', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'TP', N'O03', N'TUY PHONG', N'2013-01-26 10:17:37.677', N'ADMIN', N'2013-01-26 10:17:37.677', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'BL', N'O03', N'BAO LAM', N'2013-03-31 11:58:53.480', N'TUNG', N'2013-03-31 11:58:53.480', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'BC', N'O03', N'BAO LOC', N'2013-03-31 11:59:28.290', N'TUNG', N'2013-03-31 11:59:28.290', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'CT', N'O03', N'CAT TIEN', N'2013-03-31 11:59:42.843', N'TUNG', N'2013-03-31 11:59:42.843', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'DH', N'O03', N'DA HUOAI', N'2013-03-31 12:00:28.927', N'TUNG', N'2013-03-31 12:00:28.927', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'DT', N'O03', N'DA TEH', N'2013-03-31 12:11:48.180', N'TUNG', N'2013-03-31 12:11:48.180', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'DD', N'O03', N'DON DUONG', N'2013-03-31 12:12:09.817', N'TUNG', N'2013-03-31 12:12:09.817', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'LH', N'O03', N'LAM HA', N'2013-03-31 12:12:43.930', N'TUNG', N'2013-03-31 12:12:43.930', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'DI', N'O03', N'DI LINH', N'2013-04-07 17:24:00.417', N'TUNG', N'2013-04-07 17:24:00.417', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'DL', N'O03', N'DA LAT', N'2013-04-07 17:24:10.153', N'TUNG', N'2013-04-07 17:24:10.153', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'DU', N'O03', N'DUC TRONG', N'2013-04-08 10:02:33.587', N'TUNG', N'2013-04-08 10:02:33.587', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'KV', N'O03', N'KHANH VINH', N'2013-04-08 11:02:07.720', N'TUNG', N'2013-04-08 11:02:07.720', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NA', N'O02', N'NGHE AN', N'2013-04-08 20:40:55.987', N'TUNG', N'2013-04-08 20:40:55.987', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'VT', N'O02', N'VUNG TAU', N'2013-04-08 20:54:32.117', N'TUNG', N'2013-04-08 20:54:32.117', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'BD', N'O02', N'BINH DINH', N'2013-04-17 16:06:16.197', N'TUNG', N'2013-04-17 16:06:16.197', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'TN', N'O02', N'THAÙI NGUYEÂN', N'2013-06-15 16:48:55.327', N'TUNG', N'2013-06-15 16:48:55.327', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'TNG', N'O03', N'THAÙI NGUYEÂN', N'2013-06-15 16:57:37.890', N'TUNG', N'2013-06-15 16:57:37.890', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NB', N'O01', N'Noäi boä', N'2013-06-21 09:38:23.827', N'TUNG', N'2013-06-21 09:38:23.827', N'TUNG', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'QB', N'O02', N'QUAÛNG BÌNH', N'2013-11-19 16:25:53.343', N'khont.kt', N'2013-11-19 16:26:13.757', N'khont.kt', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'DHO', N'O03', N'ÑOÀNG HÔÙI', N'2013-11-19 16:26:59.140', N'khont.kt', N'2013-11-19 16:26:59.140', N'khont.kt', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'GL', N'O02', N'GIA LAI', N'2013-01-25 16:02:45.453', N'ADMIN', N'2013-01-25 16:02:45.453', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'PY', N'O02', N'PHUÙ YEÂN', N'2013-01-25 16:03:18.997', N'ADMIN', N'2013-01-25 16:03:18.997', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'CR', N'O03', N'CAM RANH', N'2013-01-25 16:05:07.317', N'ADMIN', N'2013-01-25 16:05:07.317', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'NH', N'O03', N'NINH HOØA', N'2013-01-25 16:06:17.240', N'ADMIN', N'2013-01-25 16:06:17.240', N'ADMIN', N'0')
GO
GO
INSERT INTO [dbo].[tb0050] ([S], [STypeID], [SName], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Disabled]) VALUES (N'ZZ', N'O03', N'ZZ', N'2013-01-25 16:07:00.457', N'ADMIN', N'2013-01-25 16:07:00.457', N'ADMIN', N'0')
GO
GO

-- ----------------------------
-- Indexes structure for table tb0050
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0050
-- ----------------------------
ALTER TABLE [dbo].[tb0050] ADD PRIMARY KEY NONCLUSTERED ([S], [STypeID])
GO
